package org.sems.sems.Mapper;

import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Select;
import org.sems.sems.entity.Gwbqk;

import java.util.List;
import java.util.Map;

@Mapper
public interface GwbqkMapper {
    @Select("SELECT * FROM GWBQK where GWDM=#{gwdm}")
    List<Gwbqk> selectByGwdm(Integer gwdm);

    @Select("SELECT * FROM GWBQK b LEFT JOIN DATA_GWDMK a ON b.GWDM = a.ID")
    List<Map<String, Object>> getGWBQKJoinedData();


    int insertNewGwbqk(Gwbqk gwbqk);
}
